Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 46633944 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.2 GiB |
| Average record size in memory | 96.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 2 |
| Numeric | 9 |
lat,lon has a high cardinality: 2651 distinct values | High cardinality |
components.co is highly overall correlated with components.no2 and 3 other fields | High correlation |
components.no2 is highly overall correlated with components.co and 5 other fields | High correlation |
components.o3 is highly overall correlated with components.no2 | High correlation |
components.so2 is highly overall correlated with components.no2 | High correlation |
components.pm2_5 is highly overall correlated with components.co and 2 other fields | High correlation |
components.pm10 is highly overall correlated with components.co and 2 other fields | High correlation |
components.nh3 is highly overall correlated with components.co and 1 other fields | High correlation |
components.no has 15286768 (32.8%) zeros | Zeros |
components.o3 has 1257649 (2.7%) zeros | Zeros |
components.nh3 has 1699413 (3.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-01-11 10:14:04.939884 |
|---|---|
| Analysis finished | 2023-01-11 10:46:45.250778 |
| Duration | 32 minutes and 40.31 seconds |
| Software version | pandas-profiling vv3.6.2 |
| Download configuration | config.json |
dt
Date
| Distinct | 17328 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 355.8 MiB |
| Minimum | 2021-01-01 00:00:00 |
|---|---|
| Maximum | 2022-12-31 23:00:00 |
main.aqi
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 355.8 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 | |
| 5 | 1369754 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 46633944 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 46633944 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46633944 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46633944 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 23120252 | |
| 2 | 15958819 | |
| 3 | 3547273 | 7.6% |
| 4 | 2637846 | 5.7% |
| 5 | 1369754 | 2.9% |
components.co
Real number (ℝ)
| Distinct | 956 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 322.23665 |
| Minimum | 77.61 |
|---|---|
| Maximum | 7583.62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 77.61 |
|---|---|
| 5-th percentile | 175.24 |
| Q1 | 220.3 |
| median | 263.69 |
| Q3 | 333.79 |
| 95-th percentile | 674.25 |
| Maximum | 7583.62 |
| Range | 7506.01 |
| Interquartile range (IQR) | 113.49 |
Descriptive statistics
| Standard deviation | 221.0768 |
|---|---|
| Coefficient of variation (CV) | 0.6860697 |
| Kurtosis | 49.495009 |
| Mean | 322.23665 |
| Median Absolute Deviation (MAD) | 51.74 |
| Skewness | 5.4298716 |
| Sum | 1.5027166 × 1010 |
| Variance | 48874.951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 230.31 | 950270 | 2.0% |
| 233.65 | 948983 | 2.0% |
| 226.97 | 946941 | 2.0% |
| 223.64 | 942458 | 2.0% |
| 236.99 | 937625 | 2.0% |
| 240.33 | 925674 | 2.0% |
| 220.3 | 924791 | 2.0% |
| 243.66 | 906438 | 1.9% |
| 216.96 | 900053 | 1.9% |
| 247 | 888640 | 1.9% |
| Other values (946) | 37362071 |
| Value | Count | Frequency (%) |
| 77.61 | 1 | < 0.1% |
| 78.44 | 2 | < 0.1% |
| 80.94 | 3 | |
| 82.61 | 2 | < 0.1% |
| 83.45 | 1 | < 0.1% |
| 84.28 | 5 | |
| 85.12 | 1 | < 0.1% |
| 85.95 | 4 | |
| 86.78 | 3 | |
| 87.62 | 4 |
| Value | Count | Frequency (%) |
| 7583.62 | 1 | < 0.1% |
| 7370 | 1 | < 0.1% |
| 6622.31 | 1 | < 0.1% |
| 6462.1 | 16 | |
| 6355.29 | 34 | |
| 6248.47 | 1 | < 0.1% |
| 6195.07 | 16 | |
| 6141.66 | 31 | |
| 6088.26 | 2 | < 0.1% |
| 6034.85 | 22 |
components.no
Real number (ℝ)
| Distinct | 1461 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8372645 |
| Minimum | 0 |
|---|---|
| Maximum | 865.46 |
| Zeros | 15286768 |
| Zeros (%) | 32.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.13 |
| Q3 | 0.98 |
| 95-th percentile | 24.14 |
| Maximum | 865.46 |
| Range | 865.46 |
| Interquartile range (IQR) | 0.98 |
Descriptive statistics
| Standard deviation | 20.905834 |
|---|---|
| Coefficient of variation (CV) | 4.3218297 |
| Kurtosis | 127.84661 |
| Mean | 4.8372645 |
| Median Absolute Deviation (MAD) | 0.13 |
| Skewness | 9.3230792 |
| Sum | 2.2558072 × 108 |
| Variance | 437.05388 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 15286768 | |
| 0.01 | 1992832 | 4.3% |
| 0.02 | 1005038 | 2.2% |
| 0.03 | 737916 | 1.6% |
| 0.04 | 596139 | 1.3% |
| 0.05 | 524989 | 1.1% |
| 0.06 | 499046 | 1.1% |
| 0.07 | 466281 | 1.0% |
| 0.08 | 448063 | 1.0% |
| 0.09 | 429436 | 0.9% |
| Other values (1451) | 24647436 |
| Value | Count | Frequency (%) |
| 0 | 15286768 | |
| 0.01 | 1992832 | 4.3% |
| 0.02 | 1005038 | 2.2% |
| 0.03 | 737916 | 1.6% |
| 0.04 | 596139 | 1.3% |
| 0.05 | 524989 | 1.1% |
| 0.06 | 499046 | 1.1% |
| 0.07 | 466281 | 1.0% |
| 0.08 | 448063 | 1.0% |
| 0.09 | 429436 | 0.9% |
| Value | Count | Frequency (%) |
| 865.46 | 16 | |
| 851.15 | 16 | |
| 808.24 | 16 | |
| 772.48 | 16 | |
| 765.32 | 16 | |
| 729.56 | 16 | |
| 715.26 | 15 | |
| 708.1 | 16 | |
| 700.95 | 28 | |
| 693.8 | 22 |
components.no2
Real number (ℝ)
| Distinct | 1306 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.295924 |
| Minimum | 0.02 |
|---|---|
| Maximum | 460.62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0.02 |
|---|---|
| 5-th percentile | 1.01 |
| Q1 | 3.34 |
| median | 7.71 |
| Q3 | 19.19 |
| 95-th percentile | 63.06 |
| Maximum | 460.62 |
| Range | 460.6 |
| Interquartile range (IQR) | 15.85 |
Descriptive statistics
| Standard deviation | 22.486814 |
|---|---|
| Coefficient of variation (CV) | 1.3799042 |
| Kurtosis | 15.760183 |
| Mean | 16.295924 |
| Median Absolute Deviation (MAD) | 5.49 |
| Skewness | 3.1586302 |
| Sum | 7.5994322 × 108 |
| Variance | 505.65681 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.57 | 221117 | 0.5% |
| 5.74 | 215291 | 0.5% |
| 5.83 | 210790 | 0.5% |
| 5.91 | 209397 | 0.4% |
| 6 | 208694 | 0.4% |
| 6.08 | 205486 | 0.4% |
| 11.14 | 205277 | 0.4% |
| 6.17 | 201904 | 0.4% |
| 11.31 | 201442 | 0.4% |
| 11.48 | 198665 | 0.4% |
| Other values (1296) | 44555881 |
| Value | Count | Frequency (%) |
| 0.02 | 56 | < 0.1% |
| 0.03 | 186 | < 0.1% |
| 0.04 | 449 | < 0.1% |
| 0.05 | 770 | < 0.1% |
| 0.06 | 1100 | < 0.1% |
| 0.07 | 1417 | |
| 0.08 | 1839 | |
| 0.09 | 2269 | |
| 0.1 | 3113 | |
| 0.11 | 3296 |
| Value | Count | Frequency (%) |
| 460.62 | 16 | < 0.1% |
| 449.66 | 62 | |
| 433.21 | 69 | |
| 416.76 | 83 | |
| 411.27 | 48 | |
| 405.79 | 62 | |
| 400.3 | 54 | |
| 394.82 | 72 | |
| 389.34 | 24 | < 0.1% |
| 378.37 | 74 |
components.o3
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 1360 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.479011 |
| Minimum | 0 |
|---|---|
| Maximum | 823.98 |
| Zeros | 1257649 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.4 |
| Q1 | 32.9 |
| median | 58.65 |
| Q3 | 82.25 |
| 95-th percentile | 125.89 |
| Maximum | 823.98 |
| Range | 823.98 |
| Interquartile range (IQR) | 49.35 |
Descriptive statistics
| Standard deviation | 40.484896 |
|---|---|
| Coefficient of variation (CV) | 0.66940407 |
| Kurtosis | 4.7504424 |
| Mean | 60.479011 |
| Median Absolute Deviation (MAD) | 24.68 |
| Skewness | 1.2158001 |
| Sum | 2.8203748 × 109 |
| Variance | 1639.0268 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1257649 | 2.7% |
| 92.98 | 428300 | 0.9% |
| 94.41 | 404396 | 0.9% |
| 95.84 | 382415 | 0.8% |
| 65.8 | 376007 | 0.8% |
| 65.09 | 375258 | 0.8% |
| 66.52 | 375136 | 0.8% |
| 60.8 | 374798 | 0.8% |
| 62.23 | 374760 | 0.8% |
| 62.94 | 372934 | 0.8% |
| Other values (1350) | 41912291 |
| Value | Count | Frequency (%) |
| 0 | 1257649 | |
| 0.01 | 192447 | 0.4% |
| 0.02 | 102880 | 0.2% |
| 0.03 | 73136 | 0.2% |
| 0.04 | 58981 | 0.1% |
| 0.05 | 47758 | 0.1% |
| 0.06 | 43477 | 0.1% |
| 0.07 | 36569 | 0.1% |
| 0.08 | 32011 | 0.1% |
| 0.09 | 30756 | 0.1% |
| Value | Count | Frequency (%) |
| 823.98 | 1 | < 0.1% |
| 732.42 | 1 | < 0.1% |
| 703.81 | 2 | < 0.1% |
| 663.76 | 3 | < 0.1% |
| 658.04 | 1 | < 0.1% |
| 652.31 | 15 | |
| 646.59 | 2 | < 0.1% |
| 640.87 | 19 | |
| 629.43 | 15 | |
| 629.42 | 3 | < 0.1% |
components.so2
Real number (ℝ)
| Distinct | 913 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8760128 |
| Minimum | 0 |
|---|---|
| Maximum | 125.89 |
| Zeros | 8794 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.19 |
| Q1 | 0.73 |
| median | 1.61 |
| Q3 | 3.34 |
| 95-th percentile | 9.78 |
| Maximum | 125.89 |
| Range | 125.89 |
| Interquartile range (IQR) | 2.61 |
Descriptive statistics
| Standard deviation | 4.1221488 |
|---|---|
| Coefficient of variation (CV) | 1.433286 |
| Kurtosis | 39.742988 |
| Mean | 2.8760128 |
| Median Absolute Deviation (MAD) | 1.07 |
| Skewness | 4.825446 |
| Sum | 1.3411982 × 108 |
| Variance | 16.992111 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.95 | 274315 | 0.6% |
| 0.51 | 264120 | 0.6% |
| 1.94 | 262059 | 0.6% |
| 0.54 | 261201 | 0.6% |
| 0.57 | 259420 | 0.6% |
| 1.97 | 257799 | 0.6% |
| 0.6 | 257668 | 0.6% |
| 2 | 254906 | 0.5% |
| 0.63 | 253794 | 0.5% |
| 0.66 | 250989 | 0.5% |
| Other values (903) | 44037673 |
| Value | Count | Frequency (%) |
| 0 | 8794 | < 0.1% |
| 0.01 | 58587 | |
| 0.02 | 83323 | |
| 0.03 | 93445 | |
| 0.04 | 98837 | |
| 0.05 | 113276 | |
| 0.06 | 115594 | |
| 0.07 | 123759 | |
| 0.08 | 133442 | |
| 0.09 | 138037 |
| Value | Count | Frequency (%) |
| 125.89 | 2 | |
| 120.16 | 1 | |
| 119.21 | 1 | |
| 118.26 | 1 | |
| 117.3 | 2 | |
| 116.35 | 1 | |
| 114.44 | 1 | |
| 113.49 | 2 | |
| 112.53 | 1 | |
| 109.67 | 1 |
components.pm2_5
Real number (ℝ)
| Distinct | 21689 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.418874 |
| Minimum | 0.5 |
|---|---|
| Maximum | 3928.36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 0.91 |
| Q1 | 3 |
| median | 5.79 |
| Q3 | 11.02 |
| 95-th percentile | 34.36 |
| Maximum | 3928.36 |
| Range | 3927.86 |
| Interquartile range (IQR) | 8.02 |
Descriptive statistics
| Standard deviation | 17.340684 |
|---|---|
| Coefficient of variation (CV) | 1.6643529 |
| Kurtosis | 546.92787 |
| Mean | 10.418874 |
| Median Absolute Deviation (MAD) | 3.4 |
| Skewness | 10.435513 |
| Sum | 4.8587321 × 108 |
| Variance | 300.69932 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.5 | 1020728 | 2.2% |
| 2.44 | 49677 | 0.1% |
| 2.17 | 49582 | 0.1% |
| 2.42 | 49503 | 0.1% |
| 2.4 | 49184 | 0.1% |
| 2.74 | 49148 | 0.1% |
| 2.15 | 48761 | 0.1% |
| 2.63 | 48742 | 0.1% |
| 2.48 | 48736 | 0.1% |
| 2.19 | 48701 | 0.1% |
| Other values (21679) | 45171182 |
| Value | Count | Frequency (%) |
| 0.5 | 1020728 | |
| 0.51 | 28900 | 0.1% |
| 0.52 | 29833 | 0.1% |
| 0.53 | 29205 | 0.1% |
| 0.54 | 29387 | 0.1% |
| 0.55 | 29369 | 0.1% |
| 0.56 | 31354 | 0.1% |
| 0.57 | 30415 | 0.1% |
| 0.58 | 29510 | 0.1% |
| 0.59 | 29883 | 0.1% |
| Value | Count | Frequency (%) |
| 3928.36 | 1 | |
| 3842.74 | 1 | |
| 3422.77 | 1 | |
| 3284.55 | 1 | |
| 3167.91 | 1 | |
| 3078.2 | 1 | |
| 2911.62 | 1 | |
| 2878.22 | 1 | |
| 2778 | 1 | |
| 2651.44 | 1 |
components.pm10
Real number (ℝ)
| Distinct | 24591 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.664832 |
| Minimum | 0.5 |
|---|---|
| Maximum | 3928.62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1.32 |
| Q1 | 4.49 |
| median | 8.92 |
| Q3 | 16.55 |
| 95-th percentile | 46.6 |
| Maximum | 3928.62 |
| Range | 3928.12 |
| Interquartile range (IQR) | 12.06 |
Descriptive statistics
| Standard deviation | 21.146175 |
|---|---|
| Coefficient of variation (CV) | 1.441965 |
| Kurtosis | 267.11637 |
| Mean | 14.664832 |
| Median Absolute Deviation (MAD) | 5.29 |
| Skewness | 7.7102106 |
| Sum | 6.8387895 × 108 |
| Variance | 447.1607 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.56 | 37465 | 0.1% |
| 0.6 | 36677 | 0.1% |
| 0.57 | 36074 | 0.1% |
| 0.62 | 36032 | 0.1% |
| 0.61 | 36010 | 0.1% |
| 0.65 | 35994 | 0.1% |
| 0.51 | 35942 | 0.1% |
| 0.59 | 35935 | 0.1% |
| 0.64 | 35624 | 0.1% |
| 0.63 | 35607 | 0.1% |
| Other values (24581) | 46272584 |
| Value | Count | Frequency (%) |
| 0.5 | 18154 | |
| 0.51 | 35942 | |
| 0.52 | 33480 | |
| 0.53 | 33550 | |
| 0.54 | 34522 | |
| 0.55 | 35458 | |
| 0.56 | 37465 | |
| 0.57 | 36074 | |
| 0.58 | 34767 | |
| 0.59 | 35935 |
| Value | Count | Frequency (%) |
| 3928.62 | 1 | |
| 3843.06 | 1 | |
| 3422.97 | 1 | |
| 3284.94 | 1 | |
| 3168.33 | 1 | |
| 3081.83 | 1 | |
| 2915.84 | 1 | |
| 2881.86 | 1 | |
| 2778.41 | 1 | |
| 2651.75 | 1 |
components.nh3
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 580 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4414392 |
| Minimum | 0 |
|---|---|
| Maximum | 172.26 |
| Zeros | 1699413 |
| Zeros (%) | 3.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.03 |
| Q1 | 0.29 |
| median | 0.7 |
| Q3 | 1.58 |
| 95-th percentile | 5.26 |
| Maximum | 172.26 |
| Range | 172.26 |
| Interquartile range (IQR) | 1.29 |
Descriptive statistics
| Standard deviation | 2.4913579 |
|---|---|
| Coefficient of variation (CV) | 1.7283822 |
| Kurtosis | 138.02426 |
| Mean | 1.4414392 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 7.5952326 |
| Sum | 67219996 |
| Variance | 6.2068643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1699413 | 3.6% |
| 0.27 | 438291 | 0.9% |
| 0.28 | 431824 | 0.9% |
| 0.55 | 414610 | 0.9% |
| 0.14 | 410292 | 0.9% |
| 0.25 | 408582 | 0.9% |
| 0.34 | 405274 | 0.9% |
| 0.59 | 396734 | 0.9% |
| 0.36 | 392979 | 0.8% |
| 0.2 | 386240 | 0.8% |
| Other values (570) | 41249705 |
| Value | Count | Frequency (%) |
| 0 | 1699413 | |
| 0.01 | 217986 | 0.5% |
| 0.02 | 222140 | 0.5% |
| 0.03 | 241559 | 0.5% |
| 0.04 | 264547 | 0.6% |
| 0.05 | 300983 | 0.6% |
| 0.06 | 304057 | 0.7% |
| 0.07 | 320969 | 0.7% |
| 0.08 | 336093 | 0.7% |
| 0.09 | 369033 | 0.8% |
| Value | Count | Frequency (%) |
| 172.26 | 2 | < 0.1% |
| 147.94 | 5 | < 0.1% |
| 145.91 | 1 | < 0.1% |
| 141.86 | 1 | < 0.1% |
| 137.81 | 1 | < 0.1% |
| 135.78 | 7 | |
| 133.75 | 12 | |
| 131.73 | 16 | |
| 129.7 | 9 | |
| 128.69 | 6 | < 0.1% |
TRT_ID
Real number (ℝ)
| Distinct | 2693 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 146994.67 |
| Minimum | 20 |
|---|---|
| Maximum | 4005907 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 355.8 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 1199 |
| Q1 | 5991 |
| median | 10320 |
| Q3 | 25802 |
| 95-th percentile | 56396 |
| Maximum | 4005907 |
| Range | 4005887 |
| Interquartile range (IQR) | 19811 |
Descriptive statistics
| Standard deviation | 713230.08 |
|---|---|
| Coefficient of variation (CV) | 4.8520811 |
| Kurtosis | 25.267716 |
| Mean | 146994.67 |
| Median Absolute Deviation (MAD) | 5071 |
| Skewness | 5.2209786 |
| Sum | 6.8549414 × 1012 |
| Variance | 5.0869715 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13756 | 17328 | < 0.1% |
| 8166 | 17328 | < 0.1% |
| 18475 | 17328 | < 0.1% |
| 6089 | 17328 | < 0.1% |
| 18099 | 17328 | < 0.1% |
| 6133 | 17328 | < 0.1% |
| 15142 | 17328 | < 0.1% |
| 7198 | 17328 | < 0.1% |
| 12504 | 17328 | < 0.1% |
| 7171 | 17328 | < 0.1% |
| Other values (2683) | 46460664 |
| Value | Count | Frequency (%) |
| 20 | 17304 | |
| 22 | 17304 | |
| 24 | 17304 | |
| 26 | 17304 | |
| 27 | 17304 | |
| 28 | 17304 | |
| 30 | 17304 | |
| 34 | 17304 | |
| 40 | 17328 | |
| 41 | 17328 |
| Value | Count | Frequency (%) |
| 4005907 | 17328 | |
| 4005667 | 17304 | |
| 4005660 | 17304 | |
| 4005608 | 17328 | |
| 4005591 | 17304 | |
| 4005581 | 17328 | |
| 4005580 | 17328 | |
| 4005572 | 17304 | |
| 4005570 | 17328 | |
| 4005561 | 17328 |
lat,lon
Categorical
| Distinct | 2651 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 355.8 MiB |
| 40.6831,-74.0066 | 64969 |
|---|---|
| 37.881,-122.2999 | 58607 |
| 35.3074,-119.0981 | 56904 |
| 29.6553,-98.6263 | 52532 |
| 29.9208,-90.0791 | 51984 |
| Other values (2646) |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 16.23421 |
| Min length | 12 |
Characters and Unicode
| Total characters | 757065231 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 47.4258,-122.2408 |
|---|---|
| 2nd row | 32.8932,-97.4587 |
| 3rd row | 40.8567,-73.1671 |
| 4th row | 34.5199,-105.8701 |
| 5th row | 39.7774,-104.8564 |
Common Values
| Value | Count | Frequency (%) |
| 40.6831,-74.0066 | 64969 | 0.1% |
| 37.881,-122.2999 | 58607 | 0.1% |
| 35.3074,-119.0981 | 56904 | 0.1% |
| 29.6553,-98.6263 | 52532 | 0.1% |
| 29.9208,-90.0791 | 51984 | 0.1% |
| 30.2285,-81.5908 | 44063 | 0.1% |
| 38.932,-77.2395 | 43370 | 0.1% |
| 26.7065,-80.1281 | 42601 | 0.1% |
| 27.8142,-82.6786 | 42575 | 0.1% |
| 33.6941,-117.8257 | 42505 | 0.1% |
| Other values (2641) | 46133834 |
Length
| Value | Count | Frequency (%) |
| 40.6831,-74.0066 | 64969 | 0.1% |
| 37.881,-122.2999 | 58607 | 0.1% |
| 35.3074,-119.0981 | 56904 | 0.1% |
| 29.6553,-98.6263 | 52532 | 0.1% |
| 29.9208,-90.0791 | 51984 | 0.1% |
| 30.2285,-81.5908 | 44063 | 0.1% |
| 38.932,-77.2395 | 43370 | 0.1% |
| 26.7065,-80.1281 | 42601 | 0.1% |
| 27.8142,-82.6786 | 42575 | 0.1% |
| 33.6941,-117.8257 | 42505 | 0.1% |
| Other values (2641) | 46133834 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 93267888 | |
| 1 | 80942156 | |
| 3 | 74738161 | |
| 7 | 62860405 | |
| 2 | 61045812 | |
| 4 | 57065366 | |
| 8 | 56286525 | |
| 9 | 52167849 | |
| , | 46633944 | 6.2% |
| - | 46633944 | 6.2% |
| Other values (3) | 125423181 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 570529455 | |
| Other Punctuation | 139901832 | 18.5% |
| Dash Punctuation | 46633944 | 6.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 80942156 | |
| 3 | 74738161 | |
| 7 | 62860405 | |
| 2 | 61045812 | |
| 4 | 57065366 | |
| 8 | 56286525 | |
| 9 | 52167849 | |
| 6 | 43772211 | |
| 5 | 42604468 | |
| 0 | 39046502 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 93267888 | |
| , | 46633944 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 46633944 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 757065231 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 93267888 | |
| 1 | 80942156 | |
| 3 | 74738161 | |
| 7 | 62860405 | |
| 2 | 61045812 | |
| 4 | 57065366 | |
| 8 | 56286525 | |
| 9 | 52167849 | |
| , | 46633944 | 6.2% |
| - | 46633944 | 6.2% |
| Other values (3) | 125423181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 757065231 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 93267888 | |
| 1 | 80942156 | |
| 3 | 74738161 | |
| 7 | 62860405 | |
| 2 | 61045812 | |
| 4 | 57065366 | |
| 8 | 56286525 | |
| 9 | 52167849 | |
| , | 46633944 | 6.2% |
| - | 46633944 | 6.2% |
| Other values (3) | 125423181 |
| components.co | components.no | components.no2 | components.o3 | components.so2 | components.pm2_5 | components.pm10 | components.nh3 | TRT_ID | main.aqi | |
|---|---|---|---|---|---|---|---|---|---|---|
| components.co | 1.000 | 0.415 | 0.782 | -0.424 | 0.460 | 0.604 | 0.540 | 0.504 | -0.045 | 0.333 |
| components.no | 0.415 | 1.000 | 0.406 | -0.180 | 0.359 | 0.357 | 0.339 | 0.315 | -0.046 | 0.243 |
| components.no2 | 0.782 | 0.406 | 1.000 | -0.558 | 0.579 | 0.563 | 0.546 | 0.533 | -0.083 | 0.334 |
| components.o3 | -0.424 | -0.180 | -0.558 | 1.000 | -0.000 | -0.219 | -0.192 | -0.223 | 0.003 | 0.375 |
| components.so2 | 0.460 | 0.359 | 0.579 | -0.000 | 1.000 | 0.443 | 0.416 | 0.277 | -0.053 | 0.182 |
| components.pm2_5 | 0.604 | 0.357 | 0.563 | -0.219 | 0.443 | 1.000 | 0.939 | 0.385 | -0.037 | 0.023 |
| components.pm10 | 0.540 | 0.339 | 0.546 | -0.192 | 0.416 | 0.939 | 1.000 | 0.379 | -0.052 | 0.027 |
| components.nh3 | 0.504 | 0.315 | 0.533 | -0.223 | 0.277 | 0.385 | 0.379 | 1.000 | -0.041 | 0.093 |
| TRT_ID | -0.045 | -0.046 | -0.083 | 0.003 | -0.053 | -0.037 | -0.052 | -0.041 | 1.000 | 0.022 |
| main.aqi | 0.333 | 0.243 | 0.334 | 0.375 | 0.182 | 0.023 | 0.027 | 0.093 | 0.022 | 1.000 |
| dt | main.aqi | components.co | components.no | components.no2 | components.o3 | components.so2 | components.pm2_5 | components.pm10 | components.nh3 | TRT_ID | lat,lon | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-01-01 | 1 | 257.02 | 0.01 | 11.65 | 48.64 | 2.80 | 2.67 | 4.79 | 0.25 | 6838 | 47.4258,-122.2408 |
| 1 | 2021-01-01 | 1 | 230.31 | 0.00 | 5.66 | 60.80 | 0.65 | 0.68 | 0.86 | 0.12 | 35618 | 32.8932,-97.4587 |
| 2 | 2021-01-01 | 1 | 297.07 | 0.01 | 15.25 | 49.35 | 2.47 | 1.54 | 2.61 | 0.85 | 9852 | 40.8567,-73.1671 |
| 3 | 2021-01-01 | 1 | 183.58 | 0.07 | 2.21 | 75.82 | 0.14 | 2.88 | 5.23 | 1.17 | 17801 | 34.5199,-105.8701 |
| 4 | 2021-01-01 | 2 | 403.88 | 3.21 | 67.17 | 13.77 | 1.64 | 16.76 | 21.83 | 1.82 | 35905 | 39.7774,-104.8564 |
| 5 | 2021-01-01 | 1 | 323.77 | 0.02 | 21.59 | 57.22 | 2.56 | 5.97 | 7.41 | 3.61 | 34155 | 45.0462,-93.3921 |
| 6 | 2021-01-01 | 4 | 540.73 | 3.16 | 54.15 | 80.11 | 10.97 | 44.67 | 51.60 | 0.40 | 5773 | 32.5869,-117.0917 |
| 7 | 2021-01-01 | 2 | 210.29 | 0.20 | 2.27 | 94.41 | 0.52 | 3.11 | 3.98 | 0.35 | 31177 | 34.6133,-118.1406 |
| 8 | 2021-01-01 | 1 | 257.02 | 0.00 | 6.86 | 65.80 | 1.03 | 0.59 | 1.20 | 0.55 | 58602 | 41.0784,-74.1667 |
| 9 | 2021-01-01 | 2 | 360.49 | 2.68 | 34.96 | 80.11 | 9.30 | 13.26 | 16.72 | 1.87 | 5723 | 33.7245,-117.7962 |
| dt | main.aqi | components.co | components.no | components.no2 | components.o3 | components.so2 | components.pm2_5 | components.pm10 | components.nh3 | TRT_ID | lat,lon | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46633934 | 2022-12-31 23:00:00 | 1 | 260.35 | 0.22 | 12.51 | 20.56 | 0.78 | 3.94 | 4.99 | 0.35 | 26391 | 30.5102,-87.2174 |
| 46633935 | 2022-12-31 23:00:00 | 1 | 360.49 | 4.58 | 27.08 | 4.65 | 1.68 | 5.27 | 6.78 | 0.30 | 20899 | 37.4123,-122.1479 |
| 46633936 | 2022-12-31 23:00:00 | 1 | 240.33 | 0.29 | 14.57 | 45.06 | 4.95 | 2.25 | 3.38 | 0.51 | 9971 | 34.0851,-118.1406 |
| 46633937 | 2022-12-31 23:00:00 | 1 | 196.93 | 0.06 | 1.78 | 53.64 | 0.29 | 1.27 | 2.03 | 0.04 | 25076 | 34.1533,-118.7617 |
| 46633938 | 2022-12-31 23:00:00 | 1 | 453.95 | 4.75 | 39.76 | 4.16 | 1.48 | 8.39 | 11.31 | 0.91 | 13557 | 42.3967,-83.2776 |
| 46633939 | 2022-12-31 23:00:00 | 1 | 310.42 | 1.29 | 27.76 | 16.45 | 2.62 | 3.44 | 4.56 | 0.49 | 34595 | 37.4255,-121.9754 |
| 46633940 | 2022-12-31 23:00:00 | 2 | 333.79 | 1.58 | 22.96 | 55.07 | 6.08 | 16.04 | 20.21 | 0.99 | 24894 | 30.0194,-95.2863 |
| 46633941 | 2022-12-31 23:00:00 | 1 | 267.03 | 0.66 | 15.77 | 32.54 | 1.62 | 2.85 | 3.86 | 0.35 | 856 | 47.6294,-122.1478 |
| 46633942 | 2022-12-31 23:00:00 | 2 | 213.62 | 0.08 | 3.90 | 63.66 | 0.26 | 0.60 | 0.81 | 0.16 | 677 | 37.9634,-122.516 |
| 46633943 | 2022-12-31 23:00:00 | 1 | 213.62 | 0.08 | 2.78 | 53.64 | 0.31 | 2.41 | 4.53 | 0.14 | 45308 | 32.6972,-117.134 |